BI-Dhananjay - 2017-04-25 - 17560 - Enhancement - Create a data source for Inventory in Explorer (Mark Harris by 2017-05-05) #hold
ENHANCEMENT
17560 - Create a data source for Inventory in Explorer
Requirement Summary
Need to create a data source for Inventory in Explorer.
Admin Info
Purpose
|
Need to create a data source for Inventory in Explorer.
|
Requested By
|
Mark Harris
|
Spec Created By
|
Dhananjay G
|
Spec Created Date
|
04/25/2017
|
Spec QA by
|
Uday Kumar P
|
Objects
|
ZIC_C03
|
Document Status
|
WIP
|
Estimates
Sl.No
|
Activity
|
Estimation in Hours
|
1
|
Research
|
08
|
2
|
Documentation
|
08
|
3
|
Development/ Config
|
40
|
4
|
Unit test in DEV
|
40
|
5
|
Unit test in QUA
|
40
|
6
|
Other activity
|
|
|
TOTAL
|
136
|
References
Prior Tickets
56700
Documents
None
Spec Changes
[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]
Sl.
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
1.
|
Finished Goods Restrict to 1000 Sales Org
|
Mark Harris
|
05/18/2017
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Need to create a data source for Inventory in Explorer.
In Scope:
Need to create a data source for Inventory in Explorer.
Out of Scope:
Other Regions
Solution Summary
1. Need to create space on inventory cube ZIC_C03.
2. Need to validate the explorer space with BW Cube.
3. Need to promote the report into BI Production after successful validation.
Solution Details
1. Developed the Inventory universe(For Raw Materials only) on top of the inventory cube ZIC_C03 and validated it with the cube values successfully. Find attached document named "Inventory Universe Validation BPD" as below:
Inventory Universe Validation BPD.docx
2. Inventory Explorer spaces for Finished Goods and Raw Materials indexed successfully in BI Dev Server.
Finished Goods Explorer Space is restricted to 1000 Sales Org.
Issues
We have already completed testing for Inventory Explorer spaces. Please find attached validation file in Documents tab under WF ticket# 56700.
We are waiting for user review and once successful NEC will promote to BI Production.